% Copyright (c) 2012, Suraj Gowda 
% All rights reserved.
% 
% Redistribution and use in source and binary forms, with or without
% modification, are permitted provided that the following conditions are met:
%     * Redistributions of source code must retain the above copyright
%       notice, this list of conditions and the following disclaimer.
%     * Redistributions in binary form must reproduce the above copyright
%       notice, this list of conditions and the following disclaimer in the
%       documentation and/or other materials provided with the distribution.
%     * Neither the name of the <organization> nor the
%       names of its contributors may be used to endorse or promote products
%       derived from this software without specific prior written permission.
% 
% THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
% ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
% WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
% DISCLAIMED. IN NO EVENT SHALL Suraj Gowda BE LIABLE FOR ANY
% DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
% (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
% LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
% ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
% (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
% SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.


function create_table_from_struct(tbl_name, s, varargin)

defaults = {...
    'datatypes_consistent', 0, ...
    'max_str_len', 100, ...
};

datatypes_consistent = get_var('datatypes_consistent', 'defaults', defaults, varargin{:});
max_str_len = get_var('max_str_len', 'defaults', defaults, varargin{:});
    
col_names = fieldnames(s);
type_list = 'id INT NOT NULL AUTO_INCREMENT, ';
for k =1:length(col_names)
    col_name = col_names{k};
    if datatypes_consistent && isstr(s.(col_name))
        col_type = sprintf('%s varchar(%d) NULL, ', col_name, max_str_len);
    % elseif datatypes_consistent && isscalar(s.(col_name))
    %     col_type = sprintf('%s FLOAT NULL, ', col_name);
    else
        col_type = sprintf('%s BLOB NULL, ', col_name);
    end
    type_list = [ type_list, col_type];
end

type_list = [type_list, 'PRIMARY KEY (id)']

mym( sprintf('create table if not exists %s (%s)', tbl_name, type_list) )


end

